November 21, 2024 - by Bill Jelen
This is a feature that does deserve to be in this book. I am putting it in the book to warn you about the feature. Next to all of the great Power Query features is a drop-down for Data From Picture. The concept - use your phone to take a picture of a receipt. Then, copy the image, use Picture From Clipboard and Excel can insert data from the picture into Excel.
Excel 2024: Use Fuzzy Match in Power Query »
November 18, 2024 - by Bill Jelen
There's a research and development team at Microsoft known as Microsoft Labs. Almost 10 years ago, it invented a free Fuzzy Match add-in for Excel. A fuzzy matching algorithm looks for words that share a percentage of characters in common.
Excel 2024: Clean Data with Power Query »
November 14, 2024 - by Bill Jelen
Power Query is built in to Windows versions of Office 365, Excel 2016, Excel 2019 and is available as a free download in Windows versions of Excel 2010 and Excel 2013. The tool is designed to extract, transform, and load data into Excel from a variety of sources.
Excel 2024: Improve Your Macro Recording »
November 11, 2024 - by Bill Jelen
I loved the 1985 version of the Macro Recorder in Lotus 1-2-3. The code was hard to understand, but it worked. There are some defaults in the Excel Macro Recorder that cause misery for anyone trying to record macros. Here are three tips to make the macro experience possibly better.
Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365)
April 2022
Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won't find anywhere else, and create automated reports that are amazingly powerful.
Programming PowerPoint with VBA
February 2022
This book assumes you already use PowerPoint and want to automate or enhance your presentations using Visual Basic for Applications (VBA). This book includes VBA samples for working with layouts, themes & masters, creating tables, drawing objects, charting, animation effects and event programming.
February 2024
This is the 7th edition of MrExcel XL. Updates for 2024 include: Remove Filter Items Using Search Box, The Consolas Font Makes it Easy to Tell Zero from the Letter O, Display Online Pictures In a Cell Using a Formula, Place Pictures In Cell From Local Computer, Using Artificial Intelligence with Copilot for Excel, and more...
The Transformative Magic of Power Query M Code in Excel and Power BI
August 2024
A beginner’s guide to mastering the art of data metamorphosis to get just the data structure needed to create insightful data analysis solution